﻿CREATE TABLE [dbo].[Employee_Dimission] (
    [id]          INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Eid]         INT           NULL,
    [Reason]      VARCHAR (MAX) NULL,
    [Proposer]    NVARCHAR (50) NULL,
    [ApplionTime] DATETIME      NULL,
    [Audit]       BIT           CONSTRAINT [DF_Employee_Dimission_Audit] DEFAULT (0) NULL,
    [Memo]        VARCHAR (MAX) NULL,
    [AuditPerson] NVARCHAR (50) NULL,
    [AuditTime]   NVARCHAR (50) NULL,
    [DTemp]       INT           CONSTRAINT [DF_Employee_Dimission_DTemp_1] DEFAULT ((1)) NULL,
    [LizhiDate]   DATETIME      NULL,
    CONSTRAINT [PK_Employee_Dimission] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'离职类别 0 劝退 1 个人申请 2 开除', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Employee_Dimission', @level2type = N'COLUMN', @level2name = N'DTemp';

